Excel VBA: The Beginner's Guide to Excel VBA Programming by Manral Umesh

Author:Manral, Umesh
Language: eng
Format: epub
Publisher: UNKNOWN
Published: 2023-09-29T00:00:00+00:00

Syntax Do Until… Loop Statements

Following is the syntax of a Do..Until loop in Excel VBA.

Flow Diagram

Author: Umesh Manral

Example:

Suppose you want to show a MsgBox with the first ten integers using VBA’s Do Until loop.

For that, you must run the loop until the next number is less or equal to 10. A loop would be stopped when the number exceeded 10.

Here is the VBA code to run this loop and display the result in a message box.

The above loop continues to work until the value of ‘i’ becomes 11. As soon as it becomes 11, the loop ends (as the ‘Until’ condition becomes True).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.